﻿<%@ WebService Language="C#" Class="HIVServices" %>
<%@ Assembly Name="InfoExpress.HIV.Domains" %>
<%@ Assembly Name="InfoExpress.HIV.DataAccess" %>

<%@ Assembly Name="InfoExpress.HIV.DataAccess.SqlClient" %>

using System;
using System.Data;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml;
using InfoExpress.HIV.Domains;
using InfoExpress.HIV.DataAccess;
using InfoExpress.HIV.DataAccess.SqlClient;


/// <summary>
///	Exposes CRUD webmethods for the HIVServices Database.
/// </summary>
[WebService(Namespace="http://localhost/InfoExpressHIV", Description="Exposes CRUD webmethods for the HIVServices Database.")]
public class HIVServices : WebService 
{
	
	/// <summary>
    /// used in exception handling for WebServices
    /// </summary>
    public enum FaultCode
    {
        /// <summary>
        /// Fault is on the client
        /// </summary>
        Client,
        /// <summary>
        /// Fault is on the server
        /// </summary>
        Server
    }


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table TrangThai.")]
	public bool TrangThaiProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table TrangThai with additional query text.")]
	public InfoExpress.HIV.Domains.TList<TrangThai> TrangThaiProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table TrangThai.")]
	public InfoExpress.HIV.Domains.TList<TrangThai> TrangThaiProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table TrangThai.")]
	public InfoExpress.HIV.Domains.TList<TrangThai> TrangThaiProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_TrangThai_Loai key.
	///		FK_TrangThai_Loai Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="LoaiId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from TrangThai filtered by the LoaiId column.")]
	public InfoExpress.HIV.Domains.TList<TrangThai> TrangThaiProvider_GetByLoaiId(System.Int32 _loaiId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.GetByLoaiId(_loaiId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("GetByLoaiId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_TrangThai index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table TrangThai filtered by the column Id that is part of the PK_TrangThai index.")]
	public InfoExpress.HIV.Domains.TrangThai TrangThaiProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table TrangThai.")]
	public InfoExpress.HIV.Domains.TrangThai TrangThaiProvider_Insert(InfoExpress.HIV.Domains.TrangThai entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<TrangThai> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<TrangThai> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.TrangThai object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table TrangThai.")]
	public void TrangThaiProvider_BulkInsert(InfoExpress.HIV.Domains.TList<TrangThai> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table TrangThai.")]
	public InfoExpress.HIV.Domains.TrangThai TrangThaiProvider_Update(InfoExpress.HIV.Domains.TrangThai entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.TrangThaiProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("TrangThaiProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="BenhNhanId">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table BenhNhanDangKy.")]
	public bool BenhNhanDangKyProvider_Delete(System.Int32 _benhNhanId)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.Delete(_benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table BenhNhanDangKy with additional query text.")]
	public InfoExpress.HIV.Domains.TList<BenhNhanDangKy> BenhNhanDangKyProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table BenhNhanDangKy.")]
	public InfoExpress.HIV.Domains.TList<BenhNhanDangKy> BenhNhanDangKyProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table BenhNhanDangKy.")]
	public InfoExpress.HIV.Domains.TList<BenhNhanDangKy> BenhNhanDangKyProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_TrangThai_BenhNhanDangKy key.
	///		FK_TrangThai_BenhNhanDangKy Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="TrangThaiId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from BenhNhanDangKy filtered by the TrangThaiId column.")]
	public InfoExpress.HIV.Domains.TList<BenhNhanDangKy> BenhNhanDangKyProvider_GetByTrangThaiId(System.Int32 _trangThaiId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.GetByTrangThaiId(_trangThaiId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("GetByTrangThaiId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_BenhNhanDangKy index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="BenhNhanId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table BenhNhanDangKy filtered by the column BenhNhanId that is part of the PK_BenhNhanDangKy index.")]
	public InfoExpress.HIV.Domains.BenhNhanDangKy BenhNhanDangKyProvider_GetByBenhNhanId(System.Int32 _benhNhanId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.GetByBenhNhanId(_benhNhanId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_GetByBenhNhanId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table BenhNhanDangKy.")]
	public InfoExpress.HIV.Domains.BenhNhanDangKy BenhNhanDangKyProvider_Insert(InfoExpress.HIV.Domains.BenhNhanDangKy entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<BenhNhanDangKy> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<BenhNhanDangKy> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.BenhNhanDangKy object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table BenhNhanDangKy.")]
	public void BenhNhanDangKyProvider_BulkInsert(InfoExpress.HIV.Domains.TList<BenhNhanDangKy> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table BenhNhanDangKy.")]
	public InfoExpress.HIV.Domains.BenhNhanDangKy BenhNhanDangKyProvider_Update(InfoExpress.HIV.Domains.BenhNhanDangKy entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	/// <summary>
	///	This method wrap the _BenhNhanDangKy_DsBenhNhanChuaDuyet stored procedure. 
	/// </summary>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _BenhNhanDangKy_DsBenhNhanChuaDuyet stored procedure.")]
	public DataSet BenhNhanDangKyProvider_DsBenhNhanChuaDuyet(int start, int pageLength)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.DsBenhNhanChuaDuyet(start, pageLength );
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_DsBenhNhanChuaDuyet", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _BenhNhanDangKy_DsBenhNhanTheoTrangThai stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.String</c> instance.</param>
		/// <param name="trangThaiId"> A <c>System.Int32?</c> instance.</param>
		/// <param name="tuNgay"> A <c>System.DateTime?</c> instance.</param>
		/// <param name="denNgay"> A <c>System.DateTime?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="TList{BenhNhanDangKy}"/> instance.</returns>
	[WebMethod(Description="This method wrap the _BenhNhanDangKy_DsBenhNhanTheoTrangThai stored procedure.")]
	public TList<BenhNhanDangKy> BenhNhanDangKyProvider_DsBenhNhanTheoTrangThai(int start, int pageLength, System.String maDonVi, System.Int32? trangThaiId, System.DateTime? tuNgay, System.DateTime? denNgay)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.DsBenhNhanTheoTrangThai(start, pageLength, maDonVi, trangThaiId, tuNgay, denNgay);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_DsBenhNhanTheoTrangThai", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _BenhNhanDangKy_LayThongTinDayDu stored procedure. 
	/// </summary>
		/// <param name="benhNhanId"> A <c>System.Int32?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _BenhNhanDangKy_LayThongTinDayDu stored procedure.")]
	public DataSet BenhNhanDangKyProvider_LayThongTinDayDu(int start, int pageLength, System.Int32? benhNhanId)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.LayThongTinDayDu(start, pageLength , benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_LayThongTinDayDu", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _BenhNhanDangKy_LaySttToiDa stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.String</c> instance.</param>
		/// <param name="maPhanLoai"> A <c>System.Int32?</c> instance.</param>
		/// <param name="year2Digit"> A <c>System.String</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _BenhNhanDangKy_LaySttToiDa stored procedure.")]
	public DataSet BenhNhanDangKyProvider_LaySttToiDa(int start, int pageLength, System.String maDonVi, System.Int32? maPhanLoai, System.String year2Digit)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.BenhNhanDangKyProvider.LaySttToiDa(start, pageLength , maDonVi, maPhanLoai, year2Digit);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("BenhNhanDangKyProvider_LaySttToiDa", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table s_Users.")]
	public bool SUsersProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table s_Users with additional query text.")]
	public InfoExpress.HIV.Domains.TList<SUsers> SUsersProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table s_Users.")]
	public InfoExpress.HIV.Domains.TList<SUsers> SUsersProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table s_Users.")]
	public InfoExpress.HIV.Domains.TList<SUsers> SUsersProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_s_Users index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table s_Users filtered by the column Id that is part of the PK_s_Users index.")]
	public InfoExpress.HIV.Domains.SUsers SUsersProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table s_Users.")]
	public InfoExpress.HIV.Domains.SUsers SUsersProvider_Insert(InfoExpress.HIV.Domains.SUsers entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<SUsers> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<SUsers> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.SUsers object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table s_Users.")]
	public void SUsersProvider_BulkInsert(InfoExpress.HIV.Domains.TList<SUsers> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table s_Users.")]
	public InfoExpress.HIV.Domains.SUsers SUsersProvider_Update(InfoExpress.HIV.Domains.SUsers entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.SUsersProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("SUsersProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ThayDoiPhacDo.")]
	public bool ThayDoiPhacDoProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ThayDoiPhacDo with additional query text.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> ThayDoiPhacDoProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ThayDoiPhacDo.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> ThayDoiPhacDoProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ThayDoiPhacDo.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> ThayDoiPhacDoProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_ThayDoiPhacDo_BenhNhanDangKy key.
	///		FK_ThayDoiPhacDo_BenhNhanDangKy Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="BenhNhanId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from ThayDoiPhacDo filtered by the BenhNhanId column.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> ThayDoiPhacDoProvider_GetByBenhNhanId(System.Int32 _benhNhanId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.GetByBenhNhanId(_benhNhanId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("GetByBenhNhanId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ThayDoiPhacDo index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ThayDoiPhacDo filtered by the column Id that is part of the PK_ThayDoiPhacDo index.")]
	public InfoExpress.HIV.Domains.ThayDoiPhacDo ThayDoiPhacDoProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ThayDoiPhacDo.")]
	public InfoExpress.HIV.Domains.ThayDoiPhacDo ThayDoiPhacDoProvider_Insert(InfoExpress.HIV.Domains.ThayDoiPhacDo entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.ThayDoiPhacDo object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ThayDoiPhacDo.")]
	public void ThayDoiPhacDoProvider_BulkInsert(InfoExpress.HIV.Domains.TList<ThayDoiPhacDo> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ThayDoiPhacDo.")]
	public InfoExpress.HIV.Domains.ThayDoiPhacDo ThayDoiPhacDoProvider_Update(InfoExpress.HIV.Domains.ThayDoiPhacDo entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	/// <summary>
	///	This method wrap the _ThayDoiPhacDo_LayPhacDoCuoi stored procedure. 
	/// </summary>
		/// <param name="benhNhanId"> A <c>System.Int32?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _ThayDoiPhacDo_LayPhacDoCuoi stored procedure.")]
	public DataSet ThayDoiPhacDoProvider_LayPhacDoCuoi(int start, int pageLength, System.Int32? benhNhanId)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.LayPhacDoCuoi(start, pageLength , benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_LayPhacDoCuoi", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _ThayDoiPhacDo_DsPhacDo stored procedure. 
	/// </summary>
		/// <param name="benhNhanId"> A <c>System.Int32?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _ThayDoiPhacDo_DsPhacDo stored procedure.")]
	public DataSet ThayDoiPhacDoProvider_DsPhacDo(int start, int pageLength, System.Int32? benhNhanId)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.ThayDoiPhacDoProvider.DsPhacDo(start, pageLength , benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiPhacDoProvider_DsPhacDo", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ThayDoiDieuTri.")]
	public bool ThayDoiDieuTriProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ThayDoiDieuTri with additional query text.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> ThayDoiDieuTriProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ThayDoiDieuTri.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> ThayDoiDieuTriProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ThayDoiDieuTri.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> ThayDoiDieuTriProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_ThayDoiDieuTri_BenhNhanDangKy key.
	///		FK_ThayDoiDieuTri_BenhNhanDangKy Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="BenhNhanId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from ThayDoiDieuTri filtered by the BenhNhanId column.")]
	public InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> ThayDoiDieuTriProvider_GetByBenhNhanId(System.Int32 _benhNhanId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.GetByBenhNhanId(_benhNhanId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("GetByBenhNhanId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ThayDoiDieuTri index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ThayDoiDieuTri filtered by the column Id that is part of the PK_ThayDoiDieuTri index.")]
	public InfoExpress.HIV.Domains.ThayDoiDieuTri ThayDoiDieuTriProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ThayDoiDieuTri.")]
	public InfoExpress.HIV.Domains.ThayDoiDieuTri ThayDoiDieuTriProvider_Insert(InfoExpress.HIV.Domains.ThayDoiDieuTri entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.ThayDoiDieuTri object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ThayDoiDieuTri.")]
	public void ThayDoiDieuTriProvider_BulkInsert(InfoExpress.HIV.Domains.TList<ThayDoiDieuTri> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ThayDoiDieuTri.")]
	public InfoExpress.HIV.Domains.ThayDoiDieuTri ThayDoiDieuTriProvider_Update(InfoExpress.HIV.Domains.ThayDoiDieuTri entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	/// <summary>
	///	This method wrap the _ThayDoiDieuTri_LayDieuTriLanCuoi stored procedure. 
	/// </summary>
		/// <param name="benhNhanId"> A <c>System.Int32?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _ThayDoiDieuTri_LayDieuTriLanCuoi stored procedure.")]
	public DataSet ThayDoiDieuTriProvider_LayDieuTriLanCuoi(int start, int pageLength, System.Int32? benhNhanId)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.ThayDoiDieuTriProvider.LayDieuTriLanCuoi(start, pageLength , benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ThayDoiDieuTriProvider_LayDieuTriLanCuoi", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ut_phacdo.")]
	public bool UtPhacdoProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_phacdo with additional query text.")]
	public InfoExpress.HIV.Domains.TList<UtPhacdo> UtPhacdoProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ut_phacdo.")]
	public InfoExpress.HIV.Domains.TList<UtPhacdo> UtPhacdoProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ut_phacdo.")]
	public InfoExpress.HIV.Domains.TList<UtPhacdo> UtPhacdoProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ut_phacdo index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_phacdo filtered by the column Id that is part of the PK_ut_phacdo index.")]
	public InfoExpress.HIV.Domains.UtPhacdo UtPhacdoProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ut_phacdo.")]
	public InfoExpress.HIV.Domains.UtPhacdo UtPhacdoProvider_Insert(InfoExpress.HIV.Domains.UtPhacdo entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<UtPhacdo> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<UtPhacdo> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.UtPhacdo object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ut_phacdo.")]
	public void UtPhacdoProvider_BulkInsert(InfoExpress.HIV.Domains.TList<UtPhacdo> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ut_phacdo.")]
	public InfoExpress.HIV.Domains.UtPhacdo UtPhacdoProvider_Update(InfoExpress.HIV.Domains.UtPhacdo entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtPhacdoProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtPhacdoProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ut_dmdv.")]
	public bool UtDmdvProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_dmdv with additional query text.")]
	public InfoExpress.HIV.Domains.TList<UtDmdv> UtDmdvProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ut_dmdv.")]
	public InfoExpress.HIV.Domains.TList<UtDmdv> UtDmdvProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ut_dmdv.")]
	public InfoExpress.HIV.Domains.TList<UtDmdv> UtDmdvProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ut_dmdv index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_dmdv filtered by the column Id that is part of the PK_ut_dmdv index.")]
	public InfoExpress.HIV.Domains.UtDmdv UtDmdvProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ut_dmdv.")]
	public InfoExpress.HIV.Domains.UtDmdv UtDmdvProvider_Insert(InfoExpress.HIV.Domains.UtDmdv entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<UtDmdv> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<UtDmdv> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.UtDmdv object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ut_dmdv.")]
	public void UtDmdvProvider_BulkInsert(InfoExpress.HIV.Domains.TList<UtDmdv> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ut_dmdv.")]
	public InfoExpress.HIV.Domains.UtDmdv UtDmdvProvider_Update(InfoExpress.HIV.Domains.UtDmdv entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmdvProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmdvProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ut_dmxn.")]
	public bool UtDmxnProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_dmxn with additional query text.")]
	public InfoExpress.HIV.Domains.TList<UtDmxn> UtDmxnProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ut_dmxn.")]
	public InfoExpress.HIV.Domains.TList<UtDmxn> UtDmxnProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ut_dmxn.")]
	public InfoExpress.HIV.Domains.TList<UtDmxn> UtDmxnProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ut_dmxn index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_dmxn filtered by the column Id that is part of the PK_ut_dmxn index.")]
	public InfoExpress.HIV.Domains.UtDmxn UtDmxnProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ut_dmxn.")]
	public InfoExpress.HIV.Domains.UtDmxn UtDmxnProvider_Insert(InfoExpress.HIV.Domains.UtDmxn entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<UtDmxn> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<UtDmxn> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.UtDmxn object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ut_dmxn.")]
	public void UtDmxnProvider_BulkInsert(InfoExpress.HIV.Domains.TList<UtDmxn> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ut_dmxn.")]
	public InfoExpress.HIV.Domains.UtDmxn UtDmxnProvider_Update(InfoExpress.HIV.Domains.UtDmxn entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmxnProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmxnProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table PhanLoaiBenhNhan.")]
	public bool PhanLoaiBenhNhanProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table PhanLoaiBenhNhan with additional query text.")]
	public InfoExpress.HIV.Domains.TList<PhanLoaiBenhNhan> PhanLoaiBenhNhanProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table PhanLoaiBenhNhan.")]
	public InfoExpress.HIV.Domains.TList<PhanLoaiBenhNhan> PhanLoaiBenhNhanProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table PhanLoaiBenhNhan.")]
	public InfoExpress.HIV.Domains.TList<PhanLoaiBenhNhan> PhanLoaiBenhNhanProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_PhanLoaiBenhNhan index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table PhanLoaiBenhNhan filtered by the column Id that is part of the PK_PhanLoaiBenhNhan index.")]
	public InfoExpress.HIV.Domains.PhanLoaiBenhNhan PhanLoaiBenhNhanProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table PhanLoaiBenhNhan.")]
	public InfoExpress.HIV.Domains.PhanLoaiBenhNhan PhanLoaiBenhNhanProvider_Insert(InfoExpress.HIV.Domains.PhanLoaiBenhNhan entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<PhanLoaiBenhNhan> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<PhanLoaiBenhNhan> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.PhanLoaiBenhNhan object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table PhanLoaiBenhNhan.")]
	public void PhanLoaiBenhNhanProvider_BulkInsert(InfoExpress.HIV.Domains.TList<PhanLoaiBenhNhan> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table PhanLoaiBenhNhan.")]
	public InfoExpress.HIV.Domains.PhanLoaiBenhNhan PhanLoaiBenhNhanProvider_Update(InfoExpress.HIV.Domains.PhanLoaiBenhNhan entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PhanLoaiBenhNhanProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PhanLoaiBenhNhanProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ut_dmuser.")]
	public bool UtDmuserProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_dmuser with additional query text.")]
	public InfoExpress.HIV.Domains.TList<UtDmuser> UtDmuserProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ut_dmuser.")]
	public InfoExpress.HIV.Domains.TList<UtDmuser> UtDmuserProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ut_dmuser.")]
	public InfoExpress.HIV.Domains.TList<UtDmuser> UtDmuserProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ut_dmuser index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_dmuser filtered by the column Id that is part of the PK_ut_dmuser index.")]
	public InfoExpress.HIV.Domains.UtDmuser UtDmuserProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ut_dmuser.")]
	public InfoExpress.HIV.Domains.UtDmuser UtDmuserProvider_Insert(InfoExpress.HIV.Domains.UtDmuser entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<UtDmuser> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<UtDmuser> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.UtDmuser object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ut_dmuser.")]
	public void UtDmuserProvider_BulkInsert(InfoExpress.HIV.Domains.TList<UtDmuser> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ut_dmuser.")]
	public InfoExpress.HIV.Domains.UtDmuser UtDmuserProvider_Update(InfoExpress.HIV.Domains.UtDmuser entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtDmuserProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtDmuserProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table Loai.")]
	public bool LoaiProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table Loai with additional query text.")]
	public InfoExpress.HIV.Domains.TList<Loai> LoaiProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table Loai.")]
	public InfoExpress.HIV.Domains.TList<Loai> LoaiProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table Loai.")]
	public InfoExpress.HIV.Domains.TList<Loai> LoaiProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_PhanLoai index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table Loai filtered by the column Id that is part of the PK_PhanLoai index.")]
	public InfoExpress.HIV.Domains.Loai LoaiProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	
	/// <summary>
	/// 	Gets rows from the datasource based on the CK_PhanLoai_TenLoai index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="TenLoai"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table Loai filtered by the column TenLoai that is part of the CK_PhanLoai_TenLoai index.")]
	public InfoExpress.HIV.Domains.Loai LoaiProvider_GetByTenLoai(System.String _tenLoai, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.GetByTenLoai(_tenLoai, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_GetByTenLoai", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table Loai.")]
	public InfoExpress.HIV.Domains.Loai LoaiProvider_Insert(InfoExpress.HIV.Domains.Loai entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<Loai> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<Loai> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.Loai object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table Loai.")]
	public void LoaiProvider_BulkInsert(InfoExpress.HIV.Domains.TList<Loai> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table Loai.")]
	public InfoExpress.HIV.Domains.Loai LoaiProvider_Update(InfoExpress.HIV.Domains.Loai entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.LoaiProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LoaiProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table pdmqh.")]
	public bool PdmqhProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmqh with additional query text.")]
	public InfoExpress.HIV.Domains.TList<Pdmqh> PdmqhProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table pdmqh.")]
	public InfoExpress.HIV.Domains.TList<Pdmqh> PdmqhProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table pdmqh.")]
	public InfoExpress.HIV.Domains.TList<Pdmqh> PdmqhProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_pdmqh index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmqh filtered by the column Id that is part of the PK_pdmqh index.")]
	public InfoExpress.HIV.Domains.Pdmqh PdmqhProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table pdmqh.")]
	public InfoExpress.HIV.Domains.Pdmqh PdmqhProvider_Insert(InfoExpress.HIV.Domains.Pdmqh entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<Pdmqh> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<Pdmqh> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.Pdmqh object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table pdmqh.")]
	public void PdmqhProvider_BulkInsert(InfoExpress.HIV.Domains.TList<Pdmqh> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table pdmqh.")]
	public InfoExpress.HIV.Domains.Pdmqh PdmqhProvider_Update(InfoExpress.HIV.Domains.Pdmqh entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmqhProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmqhProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table LichSuDieuTri.")]
	public bool LichSuDieuTriProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table LichSuDieuTri with additional query text.")]
	public InfoExpress.HIV.Domains.TList<LichSuDieuTri> LichSuDieuTriProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table LichSuDieuTri.")]
	public InfoExpress.HIV.Domains.TList<LichSuDieuTri> LichSuDieuTriProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table LichSuDieuTri.")]
	public InfoExpress.HIV.Domains.TList<LichSuDieuTri> LichSuDieuTriProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_LichSuDieuTri_BenhNhanDangKy key.
	///		FK_LichSuDieuTri_BenhNhanDangKy Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="BenhNhanId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from LichSuDieuTri filtered by the BenhNhanId column.")]
	public InfoExpress.HIV.Domains.TList<LichSuDieuTri> LichSuDieuTriProvider_GetByBenhNhanId(System.Int32 _benhNhanId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.GetByBenhNhanId(_benhNhanId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("GetByBenhNhanId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_LichSuDieuTri index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table LichSuDieuTri filtered by the column Id that is part of the PK_LichSuDieuTri index.")]
	public InfoExpress.HIV.Domains.LichSuDieuTri LichSuDieuTriProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table LichSuDieuTri.")]
	public InfoExpress.HIV.Domains.LichSuDieuTri LichSuDieuTriProvider_Insert(InfoExpress.HIV.Domains.LichSuDieuTri entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<LichSuDieuTri> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<LichSuDieuTri> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.LichSuDieuTri object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table LichSuDieuTri.")]
	public void LichSuDieuTriProvider_BulkInsert(InfoExpress.HIV.Domains.TList<LichSuDieuTri> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table LichSuDieuTri.")]
	public InfoExpress.HIV.Domains.LichSuDieuTri LichSuDieuTriProvider_Update(InfoExpress.HIV.Domains.LichSuDieuTri entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	/// <summary>
	///	This method wrap the _LichSuDieuTri_DsBenhNhanChuyenDi stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.Int32?</c> instance.</param>
		/// <param name="tuNgay"> A <c>System.DateTime?</c> instance.</param>
		/// <param name="denNgay"> A <c>System.DateTime?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	[WebMethod(Description="This method wrap the _LichSuDieuTri_DsBenhNhanChuyenDi stored procedure.")]
	public void LichSuDieuTriProvider_DsBenhNhanChuyenDi(int start, int pageLength, System.Int32? maDonVi, System.DateTime? tuNgay, System.DateTime? denNgay)
	{
		try
		{
		 InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.DsBenhNhanChuyenDi(start, pageLength, maDonVi, tuNgay, denNgay);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_DsBenhNhanChuyenDi", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _LichSuDieuTri_DsBenhNhanChuyenDen stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.Int32?</c> instance.</param>
		/// <param name="tuNgay"> A <c>System.DateTime?</c> instance.</param>
		/// <param name="denNgay"> A <c>System.DateTime?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _LichSuDieuTri_DsBenhNhanChuyenDen stored procedure.")]
	public DataSet LichSuDieuTriProvider_DsBenhNhanChuyenDen(int start, int pageLength, System.Int32? maDonVi, System.DateTime? tuNgay, System.DateTime? denNgay)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.DsBenhNhanChuyenDen(start, pageLength , maDonVi, tuNgay, denNgay);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_DsBenhNhanChuyenDen", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _LichSuDieuTri_LayLichSuMoiNhat stored procedure. 
	/// </summary>
		/// <param name="benhNhanId"> A <c>System.Int32?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="TList{LichSuDieuTri}"/> instance.</returns>
	[WebMethod(Description="This method wrap the _LichSuDieuTri_LayLichSuMoiNhat stored procedure.")]
	public TList<LichSuDieuTri> LichSuDieuTriProvider_LayLichSuMoiNhat(int start, int pageLength, System.Int32? benhNhanId)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.LichSuDieuTriProvider.LayLichSuMoiNhat(start, pageLength, benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("LichSuDieuTriProvider_LayLichSuMoiNhat", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="BenhNhanId">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ChuyenOpcBuffer.")]
	public bool ChuyenOpcBufferProvider_Delete(System.Int32 _benhNhanId)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.Delete(_benhNhanId);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ChuyenOpcBuffer with additional query text.")]
	public InfoExpress.HIV.Domains.TList<ChuyenOpcBuffer> ChuyenOpcBufferProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ChuyenOpcBuffer.")]
	public InfoExpress.HIV.Domains.TList<ChuyenOpcBuffer> ChuyenOpcBufferProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ChuyenOpcBuffer.")]
	public InfoExpress.HIV.Domains.TList<ChuyenOpcBuffer> ChuyenOpcBufferProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ChuyenOpcBuffer index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="BenhNhanId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ChuyenOpcBuffer filtered by the column BenhNhanId that is part of the PK_ChuyenOpcBuffer index.")]
	public InfoExpress.HIV.Domains.ChuyenOpcBuffer ChuyenOpcBufferProvider_GetByBenhNhanId(System.Int32 _benhNhanId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.GetByBenhNhanId(_benhNhanId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_GetByBenhNhanId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ChuyenOpcBuffer.")]
	public InfoExpress.HIV.Domains.ChuyenOpcBuffer ChuyenOpcBufferProvider_Insert(InfoExpress.HIV.Domains.ChuyenOpcBuffer entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<ChuyenOpcBuffer> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<ChuyenOpcBuffer> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.ChuyenOpcBuffer object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ChuyenOpcBuffer.")]
	public void ChuyenOpcBufferProvider_BulkInsert(InfoExpress.HIV.Domains.TList<ChuyenOpcBuffer> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ChuyenOpcBuffer.")]
	public InfoExpress.HIV.Domains.ChuyenOpcBuffer ChuyenOpcBufferProvider_Update(InfoExpress.HIV.Domains.ChuyenOpcBuffer entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	/// <summary>
	///	This method wrap the _ChuyenOpcBuffer_DsBenhNhan stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.String</c> instance.</param>
		/// <param name="benhNhanTuDo"> A <c>System.Boolean?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _ChuyenOpcBuffer_DsBenhNhan stored procedure.")]
	public DataSet ChuyenOpcBufferProvider_DsBenhNhan(int start, int pageLength, System.String maDonVi, System.Boolean? benhNhanTuDo)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.ChuyenOpcBufferProvider.DsBenhNhan(start, pageLength , maDonVi, benhNhanTuDo);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("ChuyenOpcBufferProvider_DsBenhNhan", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table DieuTri.")]
	public bool DieuTriProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table DieuTri with additional query text.")]
	public InfoExpress.HIV.Domains.TList<DieuTri> DieuTriProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table DieuTri.")]
	public InfoExpress.HIV.Domains.TList<DieuTri> DieuTriProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table DieuTri.")]
	public InfoExpress.HIV.Domains.TList<DieuTri> DieuTriProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_DieuTri_BenhNhanDangKy key.
	///		FK_DieuTri_BenhNhanDangKy Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="BenhNhanId"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from DieuTri filtered by the BenhNhanId column.")]
	public InfoExpress.HIV.Domains.TList<DieuTri> DieuTriProvider_GetByBenhNhanId(System.Int32 _benhNhanId, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.GetByBenhNhanId(_benhNhanId, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("GetByBenhNhanId", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_DieuTri index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table DieuTri filtered by the column Id that is part of the PK_DieuTri index.")]
	public InfoExpress.HIV.Domains.DieuTri DieuTriProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table DieuTri.")]
	public InfoExpress.HIV.Domains.DieuTri DieuTriProvider_Insert(InfoExpress.HIV.Domains.DieuTri entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<DieuTri> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<DieuTri> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.DieuTri object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table DieuTri.")]
	public void DieuTriProvider_BulkInsert(InfoExpress.HIV.Domains.TList<DieuTri> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table DieuTri.")]
	public InfoExpress.HIV.Domains.DieuTri DieuTriProvider_Update(InfoExpress.HIV.Domains.DieuTri entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	/// <summary>
	///	This method wrap the _DieuTri_DsBenhNhanMatHut stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.String</c> instance.</param>
		/// <param name="tuNgay"> A <c>System.DateTime?</c> instance.</param>
		/// <param name="denNgay"> A <c>System.DateTime?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	[WebMethod(Description="This method wrap the _DieuTri_DsBenhNhanMatHut stored procedure.")]
	public void DieuTriProvider_DsBenhNhanMatHut(int start, int pageLength, System.String maDonVi, System.DateTime? tuNgay, System.DateTime? denNgay)
	{
		try
		{
		 InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.DsBenhNhanMatHut(start, pageLength, maDonVi, tuNgay, denNgay);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_DsBenhNhanMatHut", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _DieuTri_LayDieuTriLanCuoi stored procedure. 
	/// </summary>
		/// <param name="maBenhNhan"> A <c>System.String</c> instance.</param>
		/// <param name="dieuTriArv"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="baoGomChamDutDieuTri"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="baoGomDangChuyenOpc"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="maDonVi"> A <c>System.Boolean?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="TList{DieuTri}"/> instance.</returns>
	[WebMethod(Description="This method wrap the _DieuTri_LayDieuTriLanCuoi stored procedure.")]
	public TList<DieuTri> DieuTriProvider_LayDieuTriLanCuoi(int start, int pageLength, System.String maBenhNhan, System.Boolean? dieuTriArv, System.Boolean? baoGomChamDutDieuTri, System.Boolean? baoGomDangChuyenOpc, System.Boolean? maDonVi)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.LayDieuTriLanCuoi(start, pageLength, maBenhNhan, dieuTriArv, baoGomChamDutDieuTri, baoGomDangChuyenOpc, maDonVi);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_LayDieuTriLanCuoi", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _DieuTri_DsBenhNhanTuVong stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.String</c> instance.</param>
		/// <param name="tuNgay"> A <c>System.DateTime?</c> instance.</param>
		/// <param name="denNgay"> A <c>System.DateTime?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _DieuTri_DsBenhNhanTuVong stored procedure.")]
	public DataSet DieuTriProvider_DsBenhNhanTuVong(int start, int pageLength, System.String maDonVi, System.DateTime? tuNgay, System.DateTime? denNgay)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.DsBenhNhanTuVong(start, pageLength , maDonVi, tuNgay, denNgay);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_DsBenhNhanTuVong", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _DieuTri_DsBenhNhan stored procedure. 
	/// </summary>
		/// <param name="maDonVi"> A <c>System.String</c> instance.</param>
		/// <param name="maBenhNhan"> A <c>System.String</c> instance.</param>
		/// <param name="tenBenhNhan"> A <c>System.String</c> instance.</param>
		/// <param name="dieuTriArv"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="chamDutDieuTri"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="tuNgay"> A <c>System.DateTime?</c> instance.</param>
		/// <param name="denNgay"> A <c>System.DateTime?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _DieuTri_DsBenhNhan stored procedure.")]
	public DataSet DieuTriProvider_DsBenhNhan(int start, int pageLength, System.String maDonVi, System.String maBenhNhan, System.String tenBenhNhan, System.Boolean? dieuTriArv, System.Boolean? chamDutDieuTri, System.DateTime? tuNgay, System.DateTime? denNgay)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.DsBenhNhan(start, pageLength , maDonVi, maBenhNhan, tenBenhNhan, dieuTriArv, chamDutDieuTri, tuNgay, denNgay);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_DsBenhNhan", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	/// <summary>
	///	This method wrap the _DieuTri_KiemTraTonTai stored procedure. 
	/// </summary>
		/// <param name="maBenhNhan"> A <c>System.String</c> instance.</param>
		/// <param name="dieuTriArv"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="baoGomChamDutDieuTri"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="baoGomDangChuyenOpc"> A <c>System.Boolean?</c> instance.</param>
		/// <param name="maDonVi"> A <c>System.Boolean?</c> instance.</param>
	/// <remark>This method is generate from a stored procedure.</remark>
	/// <returns>A <see cref="DataSet"/> instance.</returns>
	[WebMethod(Description="This method wrap the _DieuTri_KiemTraTonTai stored procedure.")]
	public DataSet DieuTriProvider_KiemTraTonTai(int start, int pageLength, System.String maBenhNhan, System.Boolean? dieuTriArv, System.Boolean? baoGomChamDutDieuTri, System.Boolean? baoGomDangChuyenOpc, System.Boolean? maDonVi)
	{
		try
		{
		return  InfoExpress.HIV.DataAccess.DataRepository.DieuTriProvider.KiemTraTonTai(start, pageLength , maBenhNhan, dieuTriArv, baoGomChamDutDieuTri, baoGomDangChuyenOpc, maDonVi);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("DieuTriProvider_KiemTraTonTai", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
		
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table pdmphxa.")]
	public bool PdmphxaProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmphxa with additional query text.")]
	public InfoExpress.HIV.Domains.TList<Pdmphxa> PdmphxaProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table pdmphxa.")]
	public InfoExpress.HIV.Domains.TList<Pdmphxa> PdmphxaProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table pdmphxa.")]
	public InfoExpress.HIV.Domains.TList<Pdmphxa> PdmphxaProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_pdmphxa index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmphxa filtered by the column Id that is part of the PK_pdmphxa index.")]
	public InfoExpress.HIV.Domains.Pdmphxa PdmphxaProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table pdmphxa.")]
	public InfoExpress.HIV.Domains.Pdmphxa PdmphxaProvider_Insert(InfoExpress.HIV.Domains.Pdmphxa entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<Pdmphxa> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<Pdmphxa> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.Pdmphxa object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table pdmphxa.")]
	public void PdmphxaProvider_BulkInsert(InfoExpress.HIV.Domains.TList<Pdmphxa> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table pdmphxa.")]
	public InfoExpress.HIV.Domains.Pdmphxa PdmphxaProvider_Update(InfoExpress.HIV.Domains.Pdmphxa entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmphxaProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmphxaProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table pdmdt.")]
	public bool PdmdtProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmdt with additional query text.")]
	public InfoExpress.HIV.Domains.TList<Pdmdt> PdmdtProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table pdmdt.")]
	public InfoExpress.HIV.Domains.TList<Pdmdt> PdmdtProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table pdmdt.")]
	public InfoExpress.HIV.Domains.TList<Pdmdt> PdmdtProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_pdmdt index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmdt filtered by the column Id that is part of the PK_pdmdt index.")]
	public InfoExpress.HIV.Domains.Pdmdt PdmdtProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table pdmdt.")]
	public InfoExpress.HIV.Domains.Pdmdt PdmdtProvider_Insert(InfoExpress.HIV.Domains.Pdmdt entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<Pdmdt> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<Pdmdt> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.Pdmdt object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table pdmdt.")]
	public void PdmdtProvider_BulkInsert(InfoExpress.HIV.Domains.TList<Pdmdt> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table pdmdt.")]
	public InfoExpress.HIV.Domains.Pdmdt PdmdtProvider_Update(InfoExpress.HIV.Domains.Pdmdt entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmdtProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmdtProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table pdmnn.")]
	public bool PdmnnProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmnn with additional query text.")]
	public InfoExpress.HIV.Domains.TList<Pdmnn> PdmnnProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table pdmnn.")]
	public InfoExpress.HIV.Domains.TList<Pdmnn> PdmnnProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table pdmnn.")]
	public InfoExpress.HIV.Domains.TList<Pdmnn> PdmnnProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_pdmnn index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmnn filtered by the column Id that is part of the PK_pdmnn index.")]
	public InfoExpress.HIV.Domains.Pdmnn PdmnnProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table pdmnn.")]
	public InfoExpress.HIV.Domains.Pdmnn PdmnnProvider_Insert(InfoExpress.HIV.Domains.Pdmnn entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<Pdmnn> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<Pdmnn> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.Pdmnn object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table pdmnn.")]
	public void PdmnnProvider_BulkInsert(InfoExpress.HIV.Domains.TList<Pdmnn> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table pdmnn.")]
	public InfoExpress.HIV.Domains.Pdmnn PdmnnProvider_Update(InfoExpress.HIV.Domains.Pdmnn entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmnnProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnnProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table ut_tinh.")]
	public bool UtTinhProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_tinh with additional query text.")]
	public InfoExpress.HIV.Domains.TList<UtTinh> UtTinhProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table ut_tinh.")]
	public InfoExpress.HIV.Domains.TList<UtTinh> UtTinhProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table ut_tinh.")]
	public InfoExpress.HIV.Domains.TList<UtTinh> UtTinhProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_ut_tinh index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table ut_tinh filtered by the column Id that is part of the PK_ut_tinh index.")]
	public InfoExpress.HIV.Domains.UtTinh UtTinhProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table ut_tinh.")]
	public InfoExpress.HIV.Domains.UtTinh UtTinhProvider_Insert(InfoExpress.HIV.Domains.UtTinh entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<UtTinh> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<UtTinh> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.UtTinh object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table ut_tinh.")]
	public void UtTinhProvider_BulkInsert(InfoExpress.HIV.Domains.TList<UtTinh> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table ut_tinh.")]
	public InfoExpress.HIV.Domains.UtTinh UtTinhProvider_Update(InfoExpress.HIV.Domains.UtTinh entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.UtTinhProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("UtTinhProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion


	
	#region Get from  Many To Many Relationship Functions
	#endregion	
	
	#region Delete Functions
		
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="Id">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	[WebMethod(Description="Delete a row from the table pdmncln.")]
	public bool PdmnclnProvider_Delete(System.Int32 _id)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.Delete(_id);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_Delete", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion
	
	#region Find Methods
	
	/// <summary>
	/// 	Returns rows meeting the whereclause condition from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query.</param>
	/// <remarks></remarks>
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmncln with additional query text.")]
	public InfoExpress.HIV.Domains.TList<Pdmncln> PdmnclnProvider_Find(string whereClause, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.Find((TransactionManager) null, whereClause, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_Find", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	#endregion Find Methods
	
	
	#region GetAll Methods
		
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <returns>Returns a <s>DataSet</s>.</returns>
	[WebMethod(Description="Get all rows from the table pdmncln.")]
	public InfoExpress.HIV.Domains.TList<Pdmncln> PdmnclnProvider_GetAll(int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.GetAll(start, pageLength, out count);		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_GetAll", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}		
	}
	
	#endregion
	
	#region GetPaged Methods
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of HIVServices objects.</returns>
	[WebMethod(Description="Get all rows from the table pdmncln.")]
	public InfoExpress.HIV.Domains.TList<Pdmncln> PdmnclnProvider_GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.GetPaged(whereClause, orderBy, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_GetPaged", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion
		
	#region Get By Foreign Key Functions
#endregion
	
	#region Get By Index Functions
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_pdmncln index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="Id"></param>
	/// <param name="count">out parameter to get total records for query</param>	
	/// <returns>Returns a DataSet.</returns>
	[WebMethod(Description="Get rows from the table pdmncln filtered by the column Id that is part of the PK_pdmncln index.")]
	public InfoExpress.HIV.Domains.Pdmncln PdmnclnProvider_GetById(System.Int32 _id, int start, int pageLength, out int count)
	{
		try
		{
		return InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.GetById(_id, start, pageLength, out count);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_GetById", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	

	#endregion Get By Index Functions
	
	#region Insert Methods
		
	/// <summary>
	/// 	Inserts an object into the datasource.
	/// </summary>	
	/// <remarks>After inserting into the datasource, the object will be returned
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a row in the table pdmncln.")]
	public InfoExpress.HIV.Domains.Pdmncln PdmnclnProvider_Insert(InfoExpress.HIV.Domains.Pdmncln entity )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.Insert(entity);
		return entity;		
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_Insert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	
	/// <summary>
	/// Inserts a InfoExpress.HIV.Domains.TList<Pdmncln> object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">InfoExpress.HIV.Domains.TList<Pdmncln> object to insert.</param>
	/// <remarks>After inserting into the datasource, the InfoExpress.HIV.Domains.Pdmncln object will be updated
	/// to refelect any changes made by the datasource. (ie: identity or computed columns)
	/// </remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Inserts a Bulk set of rows into the table pdmncln.")]
	public void PdmnclnProvider_BulkInsert(InfoExpress.HIV.Domains.TList<Pdmncln> entityList )
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.BulkInsert(entityList);
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_BulkInsert", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}
	#endregion Insert Methods
			
	#region Update Methods
		
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity"> object to update.</param>
	/// <remarks>After updating the datasource, the object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	[WebMethod(Description="Update a row in the table pdmncln.")]
	public InfoExpress.HIV.Domains.Pdmncln PdmnclnProvider_Update(InfoExpress.HIV.Domains.Pdmncln entity)
	{
		try
		{
		InfoExpress.HIV.DataAccess.DataRepository.PdmnclnProvider.Update(entity);
		return entity;
		}
		catch(SoapException soex)
		{
			throw soex;
		}
		catch(Exception ex)
		{
			throw RaiseException("PdmnclnProvider_Update", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		}
	}

	#endregion Update Methods

	#region Custom Methods
	
	
	#endregion

	
	
	/* --------------------------------------------------------
		SQL VIEWS
	----------------------------------------------------------- */

	#region General data access methods

		#region ExecuteNonQuery
		/// <summary>
		/// Executes the non query.
		/// </summary>
		/// <param name="storedProcedureName">Name of the stored procedure.</param>
		/// <param name="parameterValues">The parameter values.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteNonQueryPs", Description="This method wrap the ExecuteNonQuery method provided by the Enterprise Library Data Access Application Block.")]
		public int ExecuteNonQuery(string storedProcedureName, params object[] parameterValues)
		{
		        try
		        {
			    return InfoExpress.HIV.DataAccess.DataRepository.Provider.ExecuteNonQuery(storedProcedureName, parameterValues);
                        }
		        catch(SoapException soex)
		        {
			    throw soex;
		        }
		        catch(Exception ex)
		        {
			    throw RaiseException("ExecuteNonQuery", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		        }
		}

		/*
		/// <summary>
		/// Executes the non query.
		/// </summary>
		/// <param name="commandWrapper">The command wrapper.</param>
		[WebMethod(MessageName="ExecuteNonQueryCmd", Description="This method wrap the ExecuteNonQuery method provided by the Enterprise Library Data Access Application Block.")]
		public void ExecuteNonQuery(Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper commandWrapper)
		{
			InfoExpress.HIV.DataAccess.DataRepository.Current.ExecuteNonQuery(commandWrapper);
		}
		*/

		/// <summary>
		/// Executes the non query.
		/// </summary>
		/// <param name="commandType">Type of the command.</param>
		/// <param name="commandText">The command text.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteNonQueryQry", Description="This method wrap the ExecuteNonQuery method provided by the Enterprise Library Data Access Application Block.")]
		public int ExecuteNonQuery(CommandType commandType, string commandText)
		{
		        try
		        {
			    return InfoExpress.HIV.DataAccess.DataRepository.Provider.ExecuteNonQuery(commandType, commandText);
                        }
		        catch(SoapException soex)
		        {
			    throw soex;
		        }
		        catch(Exception ex)
		        {
			    throw RaiseException("ExecuteNonQuery", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		        }
		}
		
		#endregion

		#region ExecuteDataSet
		/// <summary>
		/// Executes the data set.
		/// </summary>
		/// <param name="storedProcedureName">Name of the stored procedure.</param>
		/// <param name="parameterValues">The parameter values.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteDataSetPs", Description="This method wrap the ExecuteDataSet method provided by the Enterprise Library Data Access Application Block.")]
		public DataSet ExecuteDataSet(string storedProcedureName, params object[] parameterValues)
		{
		        try
		        {
			    return InfoExpress.HIV.DataAccess.DataRepository.Provider.ExecuteDataSet(storedProcedureName, parameterValues);
                        }
		        catch(SoapException soex)
		        {
			    throw soex;
		        }
		        catch(Exception ex)
		        {
			    throw RaiseException("ExecuteDataSet", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		        }
		}
		
		/*
		/// <summary>
		/// Executes the data set.
		/// </summary>
		/// <param name="commandWrapper">The command wrapper.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteDataSetCmd", Description="This method wrap the ExecuteDataSet method provided by the Enterprise Library Data Access Application Block.")]
		public DataSet ExecuteDataSet(Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper commandWrapper)
		{
			return InfoExpress.HIV.DataAccess.DataRepository.Current.ExecuteDataSet(commandWrapper);
		}
		*/

		/// <summary>
		/// Executes the data set.
		/// </summary>
		/// <param name="commandType">Type of the command.</param>
		/// <param name="commandText">The command text.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteDataSetQry", Description="This method wrap the ExecuteDataSet method provided by the Enterprise Library Data Access Application Block.")]
		public DataSet ExecuteDataSet(CommandType commandType, string commandText)
		{
		        try
		        {
			    return InfoExpress.HIV.DataAccess.DataRepository.Provider.ExecuteDataSet(commandType, commandText);
                        }
		        catch(SoapException soex)
		        {
			    throw soex;
		        }
		        catch(Exception ex)
		        {
			    throw RaiseException("ExecuteDataSet", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		        }
		}		
		#endregion

		#region ExecuteScalar
		/// <summary>
		/// Executes the scalar.
		/// </summary>
		/// <param name="storedProcedureName">Name of the stored procedure.</param>
		/// <param name="parameterValues">The parameter values.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteScalarPs", Description="This method wrap the ExecuteScalar method provided by the Enterprise Library Data Access Application Block.")]
		public object ExecuteScalar(string storedProcedureName, params object[] parameterValues)
		{
		        try
		        {
			    return InfoExpress.HIV.DataAccess.DataRepository.Provider.ExecuteScalar(storedProcedureName, parameterValues);
                        }
		        catch(SoapException soex)
		        {
			    throw soex;
		        }
		        catch(Exception ex)
		        {
			    throw RaiseException("ExecuteScalar", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		        }
		}	

		/*
		/// <summary>
		/// Executes the scalar.
		/// </summary>
		/// <param name="commandWrapper">The command wrapper.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteScalarCmd", Description="This method wrap the ExecuteScalar method provided by the Enterprise Library Data Access Application Block.")]
		public object ExecuteScalar(Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper commandWrapper)
		{
			return InfoExpress.HIV.DataAccess.DataRepository.Current.ExecuteScalar(commandWrapper);
		}
		*/

		/// <summary>
		/// Executes the scalar.
		/// </summary>
		/// <param name="commandType">Type of the command.</param>
		/// <param name="commandText">The command text.</param>
		/// <returns></returns>
		[WebMethod(MessageName="ExecuteScalarQry", Description="This method wrap the ExecuteScalar method provided by the Enterprise Library Data Access Application Block.")]
		public object ExecuteScalar(CommandType commandType, string commandText)
		{
		        try
		        {
			    return InfoExpress.HIV.DataAccess.DataRepository.Provider.ExecuteScalar(commandType, commandText);	
                        }
		        catch(SoapException soex)
		        {
			    throw soex;
		        }
		        catch(Exception ex)
		        {
			    throw RaiseException("ExecuteScalar", "WSSoapException", ex.Message, "1000", ex.Source, FaultCode.Server);
		        }
		}
		
		#endregion

		#endregion
		
	
	#region Exception Handling
    /// <summary>
    /// Creates the SoapException object with all the error details
    /// </summary>
    /// <param name="uri"></param>
    /// <param name="webServiceNamespace"></param>
    /// <param name="errorMessage"></param>
    /// <param name="errorNumber"></param>
    /// <param name="errorSource"></param>
    /// <param name="code"></param>
    /// <returns></returns>
    public SoapException RaiseException(string uri, string webServiceNamespace, string errorMessage, string errorNumber, string errorSource, FaultCode code)
    {
        XmlQualifiedName faultCodeLocation = null;

        //Identify the location of the FaultCode
        switch (code)
        {
            case FaultCode.Client:
                faultCodeLocation = SoapException.ClientFaultCode;
                break;
            case FaultCode.Server:
                faultCodeLocation = SoapException.ServerFaultCode;
                break;
        }

        XmlDocument xmlDoc = new XmlDocument();

        //Create the Detail node
        XmlNode rootNode = xmlDoc.CreateNode(XmlNodeType.Element, SoapException.DetailElementName.Name, SoapException.DetailElementName.Namespace);

        //Build specific details for the SoapException
        //Add first child of detail XML element.
        XmlNode errorNode = xmlDoc.CreateNode(XmlNodeType.Element, "Error", webServiceNamespace);

        //Create and set the value for the ErrorNumber node
        XmlNode errorNumberNode = xmlDoc.CreateNode(XmlNodeType.Element, "ErrorNumber", webServiceNamespace);
        errorNumberNode.InnerText = errorNumber;

        //Create and set the value for the ErrorMessage node
        XmlNode errorMessageNode = xmlDoc.CreateNode(XmlNodeType.Element, "ErrorMessage", webServiceNamespace);
        errorMessageNode.InnerText = errorMessage;

        //Create and set the value for the ErrorSource node
        XmlNode errorSourceNode = xmlDoc.CreateNode(XmlNodeType.Element, "ErrorSource", webServiceNamespace);
        errorSourceNode.InnerText = errorSource;

        //Append the Error child element nodes to the root detail node.
        errorNode.AppendChild(errorNumberNode);
        errorNode.AppendChild(errorMessageNode);
        errorNode.AppendChild(errorSourceNode);

        //Append the Detail node to the root node
        rootNode.AppendChild(errorNode);

        //Construct the exception
        SoapException soapEx = new SoapException(errorMessage, faultCodeLocation, uri, rootNode);

        //Raise the exception  back to the caller
        return soapEx;
    }
	#endregion
}
